-- 添加订单编码
ALTER TABLE pro_task ADD client_order_code varchar(32) COMMENT '订单编码';
ALTER TABLE md_unit_measure ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
create table hrm_staff
(
    staff_id                bigint auto_increment primary key comment '员工主键id',
    staff_code              varchar(64) comment '员工编码',
    staff_name              varchar(64) not null comment '员工名称',
    contact_phone           varchar(20) comment '联系电话',
    sex                     tinyint(2) default 0 comment '用户性别（0男 1女 2未知）',
    ethnicity               varchar(64) comment '民族',
    birth_date              date comment '出生年月',
    email                   varchar(128) comment '邮箱',
    marital_status          tinyint(2) default 0 comment '婚姻状况（0-未婚，1-已婚）',
    political_outlook       tinyint(2) default 0 comment '政治面貌（0-群众，1-党员）',
    id_card                 varchar(18) comment '身份证号',
    origin                  varchar(128) comment '籍贯',
    household_address       varchar(200) comment '户口详细地址',
    current_address         varchar(200) comment '现住址',
    emergency_contact       varchar(64) comment '紧急联系人',
    relationship            varchar(64) comment '关系',
    emergency_contact_phone varchar(20) comment '紧急联系电话',
    education               tinyint(2) default 0 comment '学历（0-初中，1-高中，2-专科，4-本科，5-研究生，6-博士）',
    joined_time             datetime comment '入职日期',
    leave_time              datetime comment '离职日期',
    create_user_id          bigint comment '创建者id',
    create_by               varchar(64) comment '创建者',
    update_user_id          bigint comment '修改者id',
    update_by               varchar(64) comment '修改者',
    create_time             datetime comment '创建时间',
    update_time             datetime comment '修改时间',
    status                  tinyint(2) default 0 comment '状态（0-备选，1-面试，2-面试通过，3-入职申请，4-入职通过，5-面试未通过）',
    remark                  varchar(255) comment '备注'
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_0900_ai_ci COMMENT ='员工花名册表';

insert
into
    sys_menu
( menu_name, order_num, path, is_frame, is_cache, menu_type, visible, status, icon, create_by, module_type, create_time)
values
    ( '员工管理', 14, 'hrm/st', '1', '0', 'M', '0', '0', 'user', 'admin', '1', sysdate());

-- 菜单 SQL
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('员工登记', '2385', '1', 'hrmStaff', 'hrm/st/hrm-staff/index', 1, 0, 'C', '0', '0', 'st:hrmstaff:list', '#', 'admin', sysdate(), '', null, '员工登记菜单');

-- 按钮父菜单ID
SELECT @parentId := LAST_INSERT_ID();

-- 按钮 SQL
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('员工登记查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'st:hrmstaff:query',        '#', 'admin', sysdate(), '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('员工登记新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'st:hrmstaff:add',          '#', 'admin', sysdate(), '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('员工登记修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'st:hrmstaff:edit',         '#', 'admin', sysdate(), '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('员工登记删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'st:hrmstaff:remove',       '#', 'admin', sysdate(), '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('员工登记导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'st:hrmstaff:export',       '#', 'admin', sysdate(), '', null, '');

-- md 添加创建人id和修改人id
ALTER TABLE md_workstation ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE md_workshop ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE md_vendor ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE md_workstation_tool ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE md_workstation_worker ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE md_client ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE md_product_sip ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE md_product_sop ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE md_produt_sop ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';


-- pro_process和pro_route相关 添加创建人id和修改人id
ALTER TABLE pro_process ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE pro_process_content ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE pro_route ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE pro_route_process ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE pro_route_product ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE pro_route_product_bom ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';

-- 更新图标
UPDATE `sys_menu` SET  `icon` = '/static/icons/u1193.svg' WHERE `menu_id` = 2342;
UPDATE `sys_menu` SET  `icon` = '/static/icons/u1175.svg' WHERE `menu_id` = 2343;
UPDATE `sys_menu` SET  `icon` = '/static/icons/u1199.svg' WHERE `menu_id` = 2344;
UPDATE `sys_menu` SET  `icon` = '/static/icons/u1196.svg' WHERE `menu_id` = 2345;
UPDATE `sys_menu` SET  `icon` = '/static/icons/u1181.svg' WHERE `menu_id` = 2346;


-- 添加字段
ALTER TABLE wm_item_recpt ADD total_amount decimal(12,4) COMMENT '总金额';
ALTER TABLE wm_item_recpt_line ADD amount decimal(12,4) COMMENT '金额';
-- wm表添加创建人和修改人id
ALTER TABLE wm_issue_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_issue_header ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_item_consume ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_item_consume_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_outsource_issue ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_outsource_issue_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_outsource_recpt ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_outsource_recpt_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_package ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_package_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_barcode ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_barcode_config ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_pback_header ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_pback_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_product_produce ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_product_produce_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_product_recpt ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_product_recpt_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_product_salse ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_product_salse_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_rt_salse ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_rt_salse_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_rt_vendor ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_rt_vendor_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_sn ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_stock_taking ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_stock_taking_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_stock_taking_result ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_transaction ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_transfer ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_transfer_line ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';

-- wm表添加创建人和修改人id
ALTER TABLE wm_material_stock ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_material_stock ADD COLUMN remark varchar(500) COMMENT '备注';

-- wm表添加创建人和修改人id
ALTER TABLE wm_material_stock ADD COLUMN create_user_id BIGINT COMMENT '创建人id',ADD COLUMN update_user_id BIGINT COMMENT '修改人id';
ALTER TABLE wm_material_stock ADD COLUMN remark varchar(500) COMMENT '备注';

ALTER TABLE gen_table ADD COLUMN sub_system_name varchar(32) COMMENT '子系统名称';

-- 菜单 SQL
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `module_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_user_id`, `create_time`, `update_by`, `update_user_id`, `update_time`, `remark`, `deleted`, `deleteAt`, `version`) VALUES (2419, '面试管理', 2385, 1, 'hrmInterviewRecord', 'hrm/sm/hrm-interview-record/index', NULL, 1, 0, 'C', '1', '0', '0', 'sm:hrminterviewrecord:list', 'form', 'admin', NULL, '2024-09-15 22:20:35', 'admin', NULL, '2024-09-21 13:45:07', '面试记录菜单', 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `module_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_user_id`, `create_time`, `update_by`, `update_user_id`, `update_time`, `remark`, `deleted`, `deleteAt`, `version`) VALUES (2420, '面试记录查询', 2419, 1, '#', '', NULL, 1, 0, 'F', '1', '0', '0', 'sm:hrminterviewrecord:query', '#', 'admin', NULL, '2024-09-15 22:20:36', '', NULL, NULL, '', 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `module_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_user_id`, `create_time`, `update_by`, `update_user_id`, `update_time`, `remark`, `deleted`, `deleteAt`, `version`) VALUES (2421, '面试记录新增', 2419, 2, '#', '', NULL, 1, 0, 'F', '1', '0', '0', 'sm:hrminterviewrecord:add', '#', 'admin', NULL, '2024-09-15 22:20:36', '', NULL, NULL, '', 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `module_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_user_id`, `create_time`, `update_by`, `update_user_id`, `update_time`, `remark`, `deleted`, `deleteAt`, `version`) VALUES (2422, '面试记录修改', 2419, 3, '#', '', NULL, 1, 0, 'F', '1', '0', '0', 'sm:hrminterviewrecord:edit', '#', 'admin', NULL, '2024-09-15 22:20:37', '', NULL, NULL, '', 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `module_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_user_id`, `create_time`, `update_by`, `update_user_id`, `update_time`, `remark`, `deleted`, `deleteAt`, `version`) VALUES (2423, '面试记录删除', 2419, 4, '#', '', NULL, 1, 0, 'F', '1', '0', '0', 'sm:hrminterviewrecord:remove', '#', 'admin', NULL, '2024-09-15 22:20:37', '', NULL, NULL, '', 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `module_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_user_id`, `create_time`, `update_by`, `update_user_id`, `update_time`, `remark`, `deleted`, `deleteAt`, `version`) VALUES (2424, '面试记录导出', 2419, 5, '#', '', NULL, 1, 0, 'F', '1', '0', '0', 'sm:hrminterviewrecord:export', '#', 'admin', NULL, '2024-09-15 22:20:37', '', NULL, NULL, '', 0, '1000-01-01 00:00:00', 1);

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for hrm_interview_record
-- ----------------------------
DROP TABLE IF EXISTS `hrm_interview_record`;
CREATE TABLE `hrm_interview_record` (
                                        `interview_record_id` bigint NOT NULL AUTO_INCREMENT COMMENT '面试记录主键',
                                        `staff_id` bigint NOT NULL COMMENT '员工主键id',
                                        `staff_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '员工编码',
                                        `staff_name` varchar(64) NOT NULL COMMENT '员工名称',
                                        `rank_id` bigint DEFAULT NULL COMMENT '定级职级主键id',
                                        `rank_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '定级职级编码',
                                        `rank_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '定级职级层次',
                                        `rank_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '定级职级层次名称',
                                        `actual_salary` decimal(12,2) DEFAULT NULL COMMENT '定级薪资',
                                        `salary_expectation` decimal(12,2) DEFAULT NULL COMMENT '期望薪资',
                                        `interview_feedback` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '面试反馈',
                                        `times` tinyint DEFAULT NULL COMMENT '面试次数',
                                        `time_for_interview` datetime DEFAULT NULL COMMENT '面试时间',
                                        `interviewer_id` bigint DEFAULT NULL COMMENT '面试官id',
                                        `interviewer_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '面试官姓名',
                                        `create_user_id` bigint DEFAULT NULL COMMENT '创建者id',
                                        `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
                                        `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                        `update_user_id` bigint DEFAULT NULL COMMENT '修改者id',
                                        `update_by` varchar(64) DEFAULT NULL COMMENT '修改者',
                                        `update_time` datetime DEFAULT NULL COMMENT '修改时间',
                                        `status` tinyint DEFAULT NULL COMMENT '状态',
                                        `remark` varchar(255) DEFAULT NULL COMMENT '备注',
                                        `deleted` int DEFAULT '0' COMMENT '逻辑删除字段 0:未删除 1:已删除',
                                        `deleteAt` datetime DEFAULT '1000-01-01 00:00:00' COMMENT '逻辑删除辅助字段',
                                        `version` int DEFAULT '1' COMMENT '乐观锁',
                                        PRIMARY KEY (`interview_record_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1837469421027217411 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='面试记录表';

SET FOREIGN_KEY_CHECKS = 1;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
                                 `dict_code` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码',
                                 `dict_sort` int DEFAULT '0' COMMENT '字典排序',
                                 `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
                                 `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
                                 `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
                                 `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
                                 `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',
                                 `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
                                 `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
                                 `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
                                 `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                 `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
                                 `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                 `remark` varchar(500) DEFAULT NULL COMMENT '备注',
                                 `create_user_id` bigint DEFAULT NULL COMMENT '创建人id',
                                 `update_user_id` bigint DEFAULT NULL COMMENT '更新人id',
                                 `deleted` int DEFAULT '0' COMMENT '逻辑删除字段 0:未删除 1:已删除',
                                 `deleteAt` datetime DEFAULT '1000-01-01 00:00:00' COMMENT '逻辑删除辅助字段',
                                 `version` int DEFAULT '1' COMMENT '乐观锁',
                                 PRIMARY KEY (`dict_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=374 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典数据表';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (1, 1, '男', '0', 'sys_user_sex', '', 'primary', 'Y', '0', 'admin', '2022-04-07 00:29:32', 'admin', '2024-09-21 14:21:14', '性别男', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (2, 2, '女', '1', 'sys_user_sex', '', 'primary', 'N', '0', 'admin', '2022-04-07 00:29:32', 'admin', '2024-09-21 14:21:11', '性别女', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (3, 3, '未知', '2', 'sys_user_sex', '', 'warning', 'N', '0', 'admin', '2022-04-07 00:29:32', 'admin', '2024-07-11 09:12:06', '性别未知', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '显示菜单', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '隐藏菜单', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '正常状态', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '停用状态', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '正常状态', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '停用状态', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '默认分组', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '系统分组', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '系统默认是', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '系统默认否', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '通知', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '公告', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '正常状态', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '关闭状态', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (18, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '新增操作', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (19, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '修改操作', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (20, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '删除操作', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (21, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '授权操作', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (22, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '导出操作', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (23, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '导入操作', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (24, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '强退操作', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (25, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '生成操作', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (26, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '清空操作', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (27, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '正常状态', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (28, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '停用状态', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (100, 1, '物料', 'ITEM', 'mes_item_product', NULL, 'default', 'N', '0', 'admin', '2022-04-16 16:34:46', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (101, 2, '产品', 'PRODUCT', 'mes_item_product', NULL, 'default', 'N', '0', 'admin', '2022-04-16 16:35:02', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (102, 1, '输入字符', 'INPUTCHAR', 'sys_autocode_parttype', NULL, 'default', 'N', '0', 'admin', '2022-04-26 15:33:47', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (103, 2, '当前日期时间', 'NOWDATE', 'sys_autocode_parttype', NULL, 'default', 'N', '0', 'admin', '2022-04-26 15:34:07', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (104, 3, '固定字符', 'FIXCHAR', 'sys_autocode_parttype', NULL, 'default', 'N', '0', 'admin', '2022-04-26 15:34:27', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (105, 4, '流水号', 'SERIALNO', 'sys_autocode_parttype', NULL, 'default', 'N', '0', 'admin', '2022-04-26 15:34:53', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (106, 1, '按年', 'YEAR', 'sys_autocode_cyclemethod', NULL, 'default', 'N', '0', 'admin', '2022-04-26 15:35:17', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (107, 2, '按月', 'MONTH', 'sys_autocode_cyclemethod', NULL, 'default', 'N', '0', 'admin', '2022-04-26 15:35:29', 'admin', '2022-04-26 15:35:55', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (108, 3, '按天', 'DAY', 'sys_autocode_cyclemethod', NULL, 'default', 'N', '0', 'admin', '2022-04-26 15:36:13', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (109, 4, '按小时', 'HOUR', 'sys_autocode_cyclemethod', NULL, 'default', 'N', '0', 'admin', '2022-04-26 15:36:34', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (110, 5, '按分钟', 'MINUTE', 'sys_autocode_cyclemethod', NULL, 'default', 'N', '0', 'admin', '2022-04-26 15:36:59', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (111, 6, '按传入字符', 'OTHER', 'sys_autocode_cyclemethod', NULL, 'default', 'N', '0', 'admin', '2022-04-26 15:37:19', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (112, 1, '企业客户', 'ENTERPRISE', 'mes_client_type', NULL, 'default', 'N', '0', 'admin', '2022-05-06 20:54:37', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (113, 2, '个人', 'PERSON', 'mes_client_type', NULL, 'default', 'N', '0', 'admin', '2022-05-06 20:55:00', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (114, 1, '优质供应商', 'A', 'mes_vendor_level', NULL, 'default', 'N', '0', 'admin', '2022-05-06 22:45:52', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (115, 2, '正常', 'B', 'mes_vendor_level', NULL, 'default', 'N', '0', 'admin', '2022-05-06 22:46:02', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (116, 3, '重点关注', 'C', 'mes_vendor_level', NULL, 'default', 'N', '0', 'admin', '2022-05-06 22:46:15', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (117, 4, '劣质供应商', 'D', 'mes_vendor_level', NULL, 'default', 'N', '0', 'admin', '2022-05-06 22:46:41', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (118, 5, '黑名单', 'E', 'mes_vendor_level', NULL, 'default', 'N', '0', 'admin', '2022-05-06 22:46:54', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (119, 1, '草稿', 'PREPARE', 'mes_order_status', NULL, 'default', 'N', '0', 'admin', '2022-05-09 10:35:34', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (120, 2, '已确认', 'CONFIRMED', 'mes_order_status', NULL, 'default', 'N', '0', 'admin', '2022-05-09 10:36:37', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (121, 3, '审批中', 'APPROVING', 'mes_order_status', NULL, 'default', 'N', '0', 'admin', '2022-05-09 10:39:30', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (122, 4, '已审批', 'APPROVED', 'mes_order_status', NULL, 'default', 'N', '0', 'admin', '2022-05-09 10:39:45', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (123, 5, '已完成', 'FINISHED', 'mes_order_status', NULL, 'default', 'N', '0', 'admin', '2022-05-09 10:40:07', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (124, 1, '客户订单', 'ORDER', 'mes_workorder_sourcetype', NULL, 'default', 'N', '0', 'admin', '2022-05-09 11:23:47', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (125, 2, '库存备货', 'STORE', 'mes_workorder_sourcetype', NULL, 'default', 'N', '0', 'admin', '2022-05-09 11:24:04', 'admin', '2022-05-09 11:24:24', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (126, 1, '定期维护', 'REGULAR', 'mes_mainten_type', NULL, 'default', 'N', '0', 'admin', '2022-05-10 23:40:57', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (127, 2, '按使用次数维护', 'USAGE', 'mes_mainten_type', NULL, 'default', 'N', '0', 'admin', '2022-05-10 23:41:31', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (128, 1, '在库', 'STORE', 'mes_tool_status', NULL, 'default', 'N', '0', 'admin', '2022-05-11 20:51:13', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (129, 2, '被领用', 'ISSUE', 'mes_tool_status', NULL, 'default', 'N', '0', 'admin', '2022-05-11 20:51:36', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (130, 3, '报废', 'SCRAP', 'mes_tool_status', NULL, 'default', 'N', '0', 'admin', '2022-05-11 20:52:02', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (131, 4, '维修中', 'REPARE', 'mes_tool_status', NULL, 'default', 'N', '0', 'admin', '2022-05-11 20:52:20', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (132, 1, 'S-to-S', 'SS', 'mes_link_type', NULL, 'default', 'N', '0', 'admin', '2022-05-13 21:51:28', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (133, 2, 'F-to-F', 'FF', 'mes_link_type', NULL, 'default', 'N', '0', 'admin', '2022-05-13 21:51:51', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (134, 3, 'S-to-F', 'SF', 'mes_link_type', NULL, 'default', 'N', '0', 'admin', '2022-05-13 21:52:05', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (135, 4, 'F-to-S', 'FS', 'mes_link_type', NULL, 'default', 'N', '0', 'admin', '2022-05-13 21:52:21', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (136, 1, '秒', 'SECOND', 'mes_time_type', NULL, 'default', 'N', '0', 'admin', '2022-05-14 08:41:14', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (137, 2, '分钟', 'MINUTE', 'mes_time_type', NULL, 'default', 'N', '0', 'admin', '2022-05-14 08:41:25', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (138, 3, '小时', 'HOUR', 'mes_time_type', NULL, 'default', 'N', '0', 'admin', '2022-05-14 08:41:46', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (139, 4, '天', 'DAY', 'mes_time_type', NULL, 'default', 'N', '0', 'admin', '2022-05-14 08:41:57', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (140, 5, '周', 'WEEK', 'mes_time_type', NULL, 'default', 'N', '0', 'admin', '2022-05-14 08:42:12', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (141, 6, '月', 'MONTH', 'mes_time_type', NULL, 'default', 'N', '0', 'admin', '2022-05-14 08:42:26', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (142, 1, '尺寸', 'SIZE', 'mes_index_type', NULL, 'default', 'N', '0', 'admin', '2022-05-17 21:26:34', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (143, 2, '外观', 'APPEARANCE', 'mes_index_type', NULL, 'default', 'N', '0', 'admin', '2022-05-17 21:28:19', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (144, 3, '重量', 'WEIGHT', 'mes_index_type', NULL, 'default', 'N', '0', 'admin', '2022-05-17 21:28:31', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (145, 4, '性能', 'PERFORMANCE', 'mes_index_type', NULL, 'default', 'N', '0', 'admin', '2022-05-17 21:29:28', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (146, 5, '成分', 'COMPONENT', 'mes_index_type', NULL, 'default', 'N', '0', 'admin', '2022-05-17 21:30:34', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (147, 1, '[来料检验]', 'IQC', 'mes_qc_type', NULL, 'default', 'N', '0', 'admin', '2022-05-18 09:38:58', 'admin', '2022-05-18 10:38:43', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (148, 3, '[首检]', 'FIRST', 'mes_qc_type', NULL, 'default', 'N', '0', 'admin', '2022-05-18 09:39:19', 'admin', '2023-10-10 17:08:09', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (149, 4, '[末检]', 'FINAL', 'mes_qc_type', NULL, 'default', 'N', '0', 'admin', '2022-05-18 09:39:46', 'admin', '2023-10-10 17:08:14', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (150, 5, '[巡检]', 'PATROL', 'mes_qc_type', NULL, 'default', 'N', '0', 'admin', '2022-05-18 09:40:05', 'admin', '2023-10-10 17:08:19', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (151, 7, '[成品检验]', 'FQC', 'mes_qc_type', NULL, 'default', 'N', '0', 'admin', '2022-05-18 09:40:27', 'admin', '2023-10-18 16:01:01', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (152, 8, '[发货检验]', 'OQC', 'mes_qc_type', NULL, 'default', 'N', '0', 'admin', '2022-05-18 09:40:52', 'admin', '2023-10-18 16:01:05', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (153, 1, '致命缺陷', 'CR', 'mes_defect_level', NULL, 'default', 'N', '0', 'admin', '2022-05-19 10:24:05', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (154, 2, '严重缺陷', 'MAJ', 'mes_defect_level', NULL, 'default', 'N', '0', 'admin', '2022-05-19 10:24:20', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (155, 3, '轻微缺陷', 'MIN', 'mes_defect_level', NULL, 'default', 'N', '0', 'admin', '2022-05-19 10:24:33', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (156, 1, '检验通过', 'ACCEPT', 'mes_qc_result', NULL, 'default', 'N', '0', 'admin', '2022-05-19 16:38:07', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (157, 2, '检验不通过', 'REJECT', 'mes_qc_result', NULL, 'default', 'N', '0', 'admin', '2022-05-19 16:38:22', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (159, 1, '白班', 'SINGLE', 'mes_shift_type', NULL, 'default', 'N', '0', 'admin', '2022-06-06 21:33:56', 'admin', '2022-06-06 21:35:05', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (160, 2, '两班倒', 'SHIFT_TWO', 'mes_shift_type', NULL, 'default', 'N', '0', 'admin', '2022-06-06 21:34:19', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (161, 3, '三班倒', 'SHIFT_THREE', 'mes_shift_type', NULL, 'default', 'N', '0', 'admin', '2022-06-06 21:34:38', 'admin', '2022-06-06 21:34:45', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (162, 1, '按天', 'DAY', 'mes_shift_method', NULL, 'default', 'N', '0', 'admin', '2022-06-06 21:39:51', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (163, 2, '按周', 'WEEK', 'mes_shift_method', NULL, 'default', 'N', '0', 'admin', '2022-06-06 21:40:14', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (164, 3, '按月', 'MONTH', 'mes_shift_method', NULL, 'default', 'N', '0', 'admin', '2022-06-06 21:40:31', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (165, 4, '按季度', 'QUARTER', 'mes_shift_method', NULL, 'default', 'N', '0', 'admin', '2022-06-06 21:40:55', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (166, 1, '注塑', 'ZS', 'mes_calendar_type', NULL, 'default', 'N', '0', 'admin', '2022-06-08 13:27:23', 'admin', '2022-06-11 21:05:57', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (167, 2, '机加工', 'CNC', 'mes_calendar_type', NULL, 'default', 'N', '0', 'admin', '2022-06-08 13:27:35', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (168, 3, '组装', 'ZZ', 'mes_calendar_type', NULL, 'default', 'N', '0', 'admin', '2022-06-08 13:27:55', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (169, 4, '仓库', 'CK', 'mes_calendar_type', NULL, 'default', 'N', '0', 'admin', '2022-06-08 13:28:24', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (170, 1, '设备点检', 'CHECK', 'mes_dvsubject_type', NULL, 'default', 'N', '0', 'admin', '2022-06-16 16:50:51', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (171, 2, '设备保养', 'MAINTEN', 'mes_dvsubject_type', NULL, 'default', 'N', '0', 'admin', '2022-06-16 16:51:19', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (172, 1, '小时', 'HOUR', 'mes_cycle_type', NULL, 'default', 'N', '0', 'admin', '2022-06-16 20:47:54', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (173, 2, '天', 'DAY', 'mes_cycle_type', NULL, 'default', 'N', '0', 'admin', '2022-06-16 20:49:07', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (174, 3, '周', 'WEEK', 'mes_cycle_type', NULL, 'default', 'N', '0', 'admin', '2022-06-16 20:49:21', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (175, 4, '月', 'MONTH', 'mes_cycle_type', NULL, 'default', 'N', '0', 'admin', '2022-06-16 20:49:32', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (176, 5, '季度', 'QUARTER', 'mes_cycle_type', NULL, 'default', 'N', '0', 'admin', '2022-06-16 20:50:00', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (177, 6, '年', 'YEAR', 'mes_cycle_type', NULL, 'default', 'N', '0', 'admin', '2022-06-16 20:50:22', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (178, 1, '设备点检计划', 'CHECK', 'dv_plan_type', NULL, 'default', 'N', '0', 'admin', '2022-06-19 17:03:44', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (179, 2, '设备保养计划', 'MAINTEN', 'dv_plan_type', NULL, 'default', 'N', '0', 'admin', '2022-06-19 17:03:56', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (180, 1, 'QR二维码', 'QR_CODE', 'mes_barcode_formart', NULL, 'default', 'N', '0', 'admin', '2022-08-01 11:06:50', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (181, 2, 'EAN码', 'EAN_CODE', 'mes_barcode_formart', NULL, 'default', 'N', '0', 'admin', '2022-08-01 11:07:40', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (182, 3, 'UPC码', 'UPC_CODE', 'mes_barcode_formart', NULL, 'default', 'N', '0', 'admin', '2022-08-01 11:07:58', 'admin', '2022-08-01 11:08:03', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (183, 1, '物料产品条码', 'ITEM', 'mes_barcode_type', NULL, 'default', 'N', '0', 'admin', '2022-08-01 11:09:07', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (184, 2, '包装条码', 'PACKAGE', 'mes_barcode_type', NULL, 'default', 'N', '0', 'admin', '2022-08-01 11:10:19', 'admin', '2022-10-22 12:20:01', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (185, 3, '库存条码', 'STOCK', 'mes_barcode_type', NULL, 'default', 'N', '0', 'admin', '2022-08-01 11:10:40', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (186, 1, '修复成功', 'SUCCESS', 'mes_repair_result', NULL, 'default', 'N', '0', 'admin', '2022-08-06 11:27:48', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (187, 2, '报废', 'SCRAP', 'mes_repair_result', NULL, 'default', 'N', '0', 'admin', '2022-08-06 11:28:18', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (188, 0, '汉族', '0', 'nation_type', NULL, 'default', 'N', '0', 'admin', '2022-08-15 14:26:52', 'admin', '2022-08-15 14:27:35', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (189, 1, '首检', 'FIRST', 'mes_ipqc_type', NULL, 'default', 'N', '0', 'admin', '2022-08-29 20:19:20', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (190, 2, '末检', 'FINAL', 'mes_ipqc_type', NULL, 'default', 'N', '0', 'admin', '2022-08-29 20:19:38', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (191, 3, '自检', 'SELF', 'mes_ipqc_type', NULL, 'default', 'N', '0', 'admin', '2022-08-29 20:19:52', 'admin', '2022-08-29 20:19:57', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (192, 4, '巡检', 'PATROL', 'mes_ipqc_type', NULL, 'default', 'N', '0', 'admin', '2022-08-29 20:20:13', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (193, 5, '点检', 'CHECK', 'mes_ipqc_type', NULL, 'default', 'N', '0', 'admin', '2022-08-29 20:20:28', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (194, 6, '终检', 'FQC', 'mes_ipqc_type', NULL, 'default', 'N', '0', 'admin', '2022-08-29 20:20:44', 'admin', '2022-08-29 20:58:07', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (195, 1, '自行报工', 'SELF', 'mes_feedback_type', NULL, 'default', 'N', '0', 'admin', '2022-10-02 15:52:45', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (196, 2, '统一报工', 'UNI', 'mes_feedback_type', NULL, 'default', 'N', '0', 'admin', '2022-10-02 15:53:03', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (197, 1, '停机', 'STOP', 'mes_machinery_status', NULL, 'default', 'N', '0', 'admin', '2022-10-09 19:24:34', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (198, 2, '生产中', 'WORKING', 'mes_machinery_status', NULL, 'default', 'N', '0', 'admin', '2022-10-09 19:24:54', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (199, 3, '维修中', 'REPAIR', 'mes_machinery_status', NULL, 'default', 'N', '0', 'admin', '2022-10-09 19:25:28', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (200, 4, '设备码', 'MACHINERY', 'mes_barcode_type', NULL, 'default', 'N', '0', 'admin', '2022-10-22 12:20:35', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (201, 5, '工作站码', 'WORKSTATION', 'mes_barcode_type', NULL, 'default', 'N', '0', 'admin', '2022-10-22 12:20:57', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (202, 6, '仓库码', 'WAREHOUSE', 'mes_barcode_type', NULL, 'default', 'N', '0', 'admin', '2022-10-22 12:21:15', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (203, 1, '内部转移', 'INNER', 'mes_transfer_type', NULL, 'default', 'N', '0', 'admin', '2022-11-28 14:50:18', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (204, 2, '外部转移', 'OUTER', 'mes_transfer_type', NULL, 'default', 'N', '0', 'admin', '2022-11-28 14:50:31', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (205, 1, '公告', 'NOTICE', 'sys_message_type', NULL, 'default', 'N', '0', 'admin', '2023-03-06 19:36:32', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (206, 2, '提示', 'PROMPT', 'sys_message_type', NULL, 'default', 'N', '0', 'admin', '2023-03-06 19:36:56', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (207, 3, '告警', 'WARNING', 'sys_message_type', NULL, 'default', 'N', '0', 'admin', '2023-03-06 19:37:19', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (208, 4, '聊天消息', 'CHAT', 'sys_message_type', NULL, 'default', 'N', '0', 'admin', '2023-03-06 19:37:42', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (209, 1, '普通', 'A', 'sys_message_level', NULL, 'default', 'N', '0', 'admin', '2023-03-06 19:38:25', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (210, 2, '警告', 'B', 'sys_message_level', NULL, 'default', 'N', '0', 'admin', '2023-03-06 19:38:35', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (211, 3, '紧急', 'C', 'sys_message_level', NULL, 'default', 'N', '0', 'admin', '2023-03-06 19:38:47', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (212, 1, '未读', 'UNREAD', 'sys_message_status', NULL, 'default', 'N', '0', 'admin', '2023-03-06 19:39:30', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (213, 2, '已读', 'READ', 'sys_message_status', NULL, 'default', 'N', '0', 'admin', '2023-03-06 19:39:42', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (214, 3, '已处理', 'PROCEED', 'sys_message_status', NULL, 'default', 'N', '0', 'admin', '2023-03-06 19:40:15', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (215, 1, '标签打印机', 'LABEL', 'mes_printer_type', NULL, 'default', 'N', '0', 'admin', '2023-09-01 10:57:25', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (216, 1, '网线连接', 'NET', 'mes_conn_type', NULL, 'default', 'N', '0', 'admin', '2023-09-01 10:59:15', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (217, 2, 'USB连接', 'USB', 'mes_conn_type', NULL, 'default', 'N', '0', 'admin', '2023-09-01 10:59:32', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (218, 3, 'WIFI连接', 'WIFI', 'mes_conn_type', NULL, 'default', 'N', '0', 'admin', '2023-09-01 10:59:54', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (219, 4, '蓝牙连接', 'BLUETOOTH', 'mes_conn_type', NULL, 'default', 'N', '0', 'admin', '2023-09-01 11:00:06', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (220, 1, '就绪', 'READY', 'mes_printer_status', NULL, 'default', 'N', '0', 'admin', '2023-09-01 11:01:24', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (221, 2, '离线', 'OFFLINE', 'mes_printer_status', NULL, 'default', 'N', '0', 'admin', '2023-09-01 11:01:42', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (222, 3, '故障', 'ERROR', 'mes_printer_status', NULL, 'default', 'N', '0', 'admin', '2023-09-01 11:01:55', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (223, 2, '[过程检验]', 'PQC', 'mes_qc_type', NULL, 'default', 'N', '0', 'admin', '2023-10-10 17:07:27', 'admin', '2023-10-10 17:08:03', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (224, 6, '[自检]', 'SELF', 'mes_qc_type', NULL, 'default', 'N', '0', 'admin', '2023-10-18 16:00:55', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (225, 1, '自产', 'SELF', 'mes_workorder_type', NULL, 'default', 'N', '0', 'admin', '2023-10-29 22:16:16', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (226, 2, '外协', 'OUTSOURCE', 'mes_workorder_type', NULL, 'default', 'N', '0', 'admin', '2023-10-29 22:16:33', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (227, 3, '外购', 'PURCHASE', 'mes_workorder_type', NULL, 'default', 'N', '0', 'admin', '2023-10-29 22:16:48', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (230, 0, '第一层', '1', 'mes_item_level', NULL, 'default', 'N', '0', 'admin', '2024-05-07 08:31:05', 'admin', '2024-05-07 08:31:19', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (231, 1, '第二层', '2', 'mes_item_level', NULL, 'default', 'N', '0', 'admin', '2024-05-07 08:31:27', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (232, 2, '第三层', '3', 'mes_item_level', NULL, 'default', 'N', '0', 'admin', '2024-05-07 08:31:34', 'admin', '2024-05-07 08:31:40', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (233, 3, '第四层', '4', 'mes_item_level', NULL, 'default', 'N', '0', 'admin', '2024-05-07 08:31:47', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (234, 0, '草稿', 'PREPARE', 'mes_client_order_status', NULL, 'default', 'N', '0', 'admin', '2024-05-26 16:04:55', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (235, 1, '已生成生产订单', 'WORK_ORDER_FINISHED', 'mes_client_order_status', NULL, 'default', 'N', '0', 'admin', '2024-05-26 16:05:10', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (236, 1, '管理后台', '1', 'sys_module_type', NULL, 'default', 'N', '0', 'admin', '2024-06-10 07:02:01', 'admin', '2024-06-10 09:03:02', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (237, 2, '移动端', '2', 'sys_module_type', NULL, 'default', 'N', '0', 'admin', '2024-06-10 07:02:13', 'admin', '2024-06-10 09:03:06', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (238, 3, '平板端', '3', 'sys_module_type', NULL, 'default', 'N', '0', 'admin', '2024-06-10 07:02:26', 'admin', '2024-06-10 09:03:09', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (239, 6, '已拒绝', 'REFUSE', 'mes_order_status', NULL, 'default', 'N', '0', 'admin', '2024-06-12 15:02:21', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (240, 0, '未婚', '0', 'hrm_marital_status', NULL, 'info', 'N', '0', 'admin', '2024-07-11 07:20:15', 'admin', '2024-07-11 09:11:10', '0-未婚', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (241, 1, '已婚', '1', 'hrm_marital_status', NULL, 'primary', 'N', '0', 'admin', '2024-07-11 07:21:10', 'admin', '2024-07-11 09:11:20', '1-未婚', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (242, 0, '群众', '0', 'hrm_political_outlook', NULL, 'info', 'N', '0', 'admin', '2024-07-11 07:23:30', 'admin', '2024-07-11 09:10:38', '0-群众', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (243, 1, '党员', '1', 'hrm_political_outlook', NULL, 'primary', 'N', '0', 'admin', '2024-07-11 07:24:07', 'admin', '2024-07-11 09:10:48', '1-党员', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (244, 0, '初中', '0', 'hrm_education', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '0-初中', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (245, 1, '高中', '1', 'hrm_education', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '1-高中', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (246, 2, '专科', '2', 'hrm_education', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', 'admin', '2024-07-11 07:41:16', '2-专科', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (247, 3, '本科', '3', 'hrm_education', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', 'admin', '2024-07-11 07:41:21', '3-本科', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (248, 4, '研究生', '4', 'hrm_education', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', 'admin', '2024-07-11 07:41:27', '4-研究生', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (249, 5, '博士', '5', 'hrm_education', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', 'admin', '2024-07-11 07:41:32', '5-博士', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (250, 0, '备选', '0', 'hrm_staff_status', 'info', 'primary', 'N', '0', 'admin', '2024-07-11 15:16:34', 'admin', '2024-09-20 19:42:08', '', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (251, 1, '面试', '10', 'hrm_staff_status', 'info', 'primary', 'N', '0', 'admin', '2024-07-11 15:16:34', 'admin', '2024-09-20 19:42:11', '', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (252, 2, '面试通过', '20', 'hrm_staff_status', NULL, 'success', 'N', '0', 'admin', '2024-07-11 15:16:34', 'admin', '2024-09-20 19:42:14', '', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (253, 4, '入职申请', '30', 'hrm_staff_status', NULL, 'primary', 'N', '0', 'admin', '2024-07-11 15:16:34', 'admin', '2024-09-20 19:42:21', '', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (254, 5, '入职通过', '40', 'hrm_staff_status', NULL, 'success', 'N', '0', 'admin', '2024-07-11 15:16:34', 'admin', '2024-09-20 19:42:24', '', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (255, 3, '面试未通过', '21', 'hrm_staff_status', NULL, 'danger', 'N', '0', 'admin', '2024-07-11 15:16:34', 'admin', '2024-09-20 19:42:17', '', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (311, 1, '汉族', '1', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '1-汉族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (312, 2, '蒙古族', '2', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '2-蒙古族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (313, 3, '回族', '3', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '3-回族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (314, 4, '藏族', '4', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '4-藏族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (315, 5, '维吾尔族', '5', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '5-维吾尔族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (316, 6, '苗族', '6', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '6-苗族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (317, 7, '彝族', '7', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '7-彝族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (318, 8, '壮族', '8', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '8-壮族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (319, 9, '布依族', '9', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '9-布依族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (320, 10, '朝鲜族', '10', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '10-朝鲜族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (321, 11, '满族', '11', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '11-满族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (322, 12, '侗族', '12', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '12-侗族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (323, 13, '瑶族', '13', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '13-瑶族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (324, 14, '白族', '14', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '14-白族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (325, 15, '土家族', '15', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '15-土家族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (326, 16, '哈尼族', '16', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '16-哈尼族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (327, 17, '哈萨克族', '17', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '17-哈萨克族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (328, 18, '傣族', '18', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '18-傣族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (329, 19, '黎族', '19', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '19-黎族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (330, 20, '傈僳族', '20', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '20-傈僳族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (331, 21, '佤族', '21', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '21-佤族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (332, 22, '畲族', '22', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '22-畲族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (333, 23, '高山族', '23', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '23-高山族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (334, 24, '拉祜族', '24', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '24-拉祜族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (335, 25, '水族', '25', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '25-水族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (336, 26, '东乡族', '26', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '26-东乡族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (337, 27, '纳西族', '27', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '27-纳西族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (338, 28, '景颇族', '28', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '28-景颇族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (339, 29, '柯尔克孜族', '29', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '29-柯尔克孜族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (340, 30, '土族', '30', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '30-土族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (341, 31, '达斡尔族', '31', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '31-达斡尔族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (342, 32, '仫佬族', '32', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '32-仫佬族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (343, 33, '羌族', '33', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '33-羌族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (344, 34, '布朗族', '34', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '34-布朗族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (345, 35, '撒拉族', '35', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '35-撒拉族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (346, 36, '毛南族', '36', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '36-毛南族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (347, 37, '仡佬族', '37', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '37-仡佬族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (348, 38, '锡伯族', '38', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '38-锡伯族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (349, 39, '阿昌族', '39', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '39-阿昌族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (350, 40, '普米族', '40', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '40-普米族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (351, 41, '塔吉克族', '41', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '41-塔吉克族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (352, 42, '怒族', '42', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '42-怒族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (353, 43, '乌孜别克族', '43', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '43-乌孜别克族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (354, 44, '俄罗斯族', '44', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '44-俄罗斯族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (355, 45, '鄂温克族', '45', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '45-鄂温克族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (356, 46, '德昂族', '46', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '46-德昂族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (357, 47, '保安族', '47', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '47-保安族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (358, 48, '裕固族', '48', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '48-裕固族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (359, 49, '京族', '49', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '49-京族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (360, 50, '塔塔尔族', '50', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '50-塔塔尔族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (361, 51, '独龙族', '51', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '51-独龙族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (362, 52, '鄂伦春族', '52', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '52-鄂伦春族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (363, 53, '赫哲族', '53', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '53-赫哲族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (364, 54, '门巴族', '54', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '54-门巴族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (365, 55, '珞巴族', '55', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '55-珞巴族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (366, 56, '基诺族', '56', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '56-基诺族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (367, 57, '其他', '57', 'hrm_ethnicity', NULL, 'default', 'N', '0', 'admin', '2024-07-11 15:16:34', '', NULL, '57-其他', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (368, 6, '试用期', '50', 'hrm_staff_status', NULL, 'primary', 'N', '0', 'admin', '2024-09-12 16:51:53', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (369, 7, '已转正', '60', 'hrm_staff_status', NULL, 'success', 'N', '0', 'admin', '2024-09-12 16:52:17', 'admin', '2024-09-12 16:52:53', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (370, 8, '已离职', '100', 'hrm_staff_status', NULL, 'danger', 'N', '0', 'admin', '2024-09-12 16:52:33', 'admin', '2024-09-12 16:52:56', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (371, 5, '入职申请被拒绝', '41', 'hrm_staff_status', NULL, 'danger', 'N', '0', 'admin', '2024-09-12 16:54:56', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (372, 3, '待定', '22', 'hrm_staff_status', NULL, 'primary', 'N', '0', 'admin', '2024-09-13 23:05:34', 'admin', '2024-09-13 23:05:40', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (373, 1, '待复试', '11', 'hrm_staff_status', NULL, 'primary', 'N', '0', 'admin', '2024-09-20 19:42:47', 'admin', '2024-09-20 19:43:10', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
                                 `dict_id` bigint NOT NULL AUTO_INCREMENT COMMENT '字典主键',
                                 `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',
                                 `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
                                 `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
                                 `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
                                 `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                 `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
                                 `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                 `remark` varchar(500) DEFAULT NULL COMMENT '备注',
                                 `create_user_id` bigint DEFAULT NULL COMMENT '创建人id',
                                 `update_user_id` bigint DEFAULT NULL COMMENT '更新人id',
                                 `deleted` int DEFAULT '0' COMMENT '逻辑删除字段 0:未删除 1:已删除',
                                 `deleteAt` datetime DEFAULT '1000-01-01 00:00:00' COMMENT '逻辑删除辅助字段',
                                 `version` int DEFAULT '1' COMMENT '乐观锁',
                                 PRIMARY KEY (`dict_id`) USING BTREE,
                                 UNIQUE KEY `dict_type` (`dict_type`)
) ENGINE=InnoDB AUTO_INCREMENT=1811329501246271491 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='字典类型表';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '用户性别列表', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '菜单状态列表', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '系统开关列表', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '任务状态列表', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '任务分组列表', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '系统是否列表', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '通知类型列表', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '通知状态列表', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '操作类型列表', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2022-04-07 00:29:32', '', NULL, '登录状态列表', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (100, '物料or产品', 'mes_item_product', '0', 'admin', '2022-04-16 16:34:20', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (101, '编码规则组成类型', 'sys_autocode_parttype', '0', 'admin', '2022-04-26 15:32:42', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (102, '编码规则组成循环方式', 'sys_autocode_cyclemethod', '0', 'admin', '2022-04-26 15:33:02', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (103, '客户类型', 'mes_client_type', '0', 'admin', '2022-05-06 20:53:28', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (104, '供应商级别', 'mes_vendor_level', '0', 'admin', '2022-05-06 22:44:56', 'admin', '2022-05-06 22:45:35', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (105, '单据状态【通用】', 'mes_order_status', '0', 'admin', '2022-05-09 10:34:41', 'admin', '2022-05-09 10:35:10', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (106, '生产工单来源', 'mes_workorder_sourcetype', '0', 'admin', '2022-05-09 11:23:22', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (107, '维护类型表', 'mes_mainten_type', '0', 'admin', '2022-05-10 23:40:36', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (108, '工装夹具状态', 'mes_tool_status', '0', 'admin', '2022-05-11 20:50:46', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (109, '工序关系类型', 'mes_link_type', '0', 'admin', '2022-05-13 21:50:44', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (110, '时间单位', 'mes_time_type', '0', 'admin', '2022-05-14 08:40:53', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (111, '检测项类型', 'mes_index_type', '0', 'admin', '2022-05-17 21:26:05', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (112, '检测类型', 'mes_qc_type', '0', 'admin', '2022-05-18 09:38:32', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (113, '缺陷等级', 'mes_defect_level', '0', 'admin', '2022-05-19 10:23:38', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (114, '检验结果', 'mes_qc_result', '0', 'admin', '2022-05-19 16:37:45', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (116, '倒班方式', 'mes_shift_type', '0', 'admin', '2022-06-06 21:33:17', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (117, '轮班方式', 'mes_shift_method', '0', 'admin', '2022-06-06 21:39:26', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (118, '排班类型', 'mes_calendar_type', '0', 'admin', '2022-06-08 13:26:56', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (119, '设备点检保养项目类型', 'mes_dvsubject_type', '0', 'admin', '2022-06-16 16:50:14', 'admin', '2022-06-16 16:50:29', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (120, '设备点检频率', 'mes_cycle_type', '0', 'admin', '2022-06-16 20:47:19', 'admin', '2022-06-16 20:51:22', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (121, '设备点检保养计划类型', 'dv_plan_type', '0', 'admin', '2022-06-19 17:03:18', 'admin', '2022-06-19 17:04:17', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (122, '条码格式', 'mes_barcode_formart', '0', 'admin', '2022-08-01 11:05:54', 'admin', '2022-08-01 11:06:15', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (123, '条码类型', 'mes_barcode_type', '0', 'admin', '2022-08-01 11:08:27', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (124, '维修结果', 'mes_repair_result', '0', 'admin', '2022-08-06 11:27:05', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (125, '民族', 'nation_type', '0', 'admin', '2022-08-15 14:25:55', 'admin', '2022-08-15 14:26:34', '民族', NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (126, '过程质量检验类型', 'mes_ipqc_type', '0', 'admin', '2022-08-29 20:18:48', 'admin', '2022-08-29 20:18:59', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (127, '生产报工类型', 'mes_feedback_type', '0', 'admin', '2022-10-02 15:51:21', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (128, '设备状态', 'mes_machinery_status', '0', 'admin', '2022-10-09 19:23:54', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (129, '转移单类型', 'mes_transfer_type', '0', 'admin', '2022-11-28 14:49:46', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (130, '消息类型', 'sys_message_type', '0', 'admin', '2023-03-06 19:35:12', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (131, '消息级别', 'sys_message_level', '0', 'admin', '2023-03-06 19:38:07', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (132, '消息状态', 'sys_message_status', '0', 'admin', '2023-03-06 19:39:16', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (133, '打印机类型', 'mes_printer_type', '0', 'admin', '2023-09-01 10:56:38', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (134, '打印机连接类型', 'mes_conn_type', '0', 'admin', '2023-09-01 10:58:47', 'admin', '2023-09-01 10:59:00', NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (135, '打印机状态', 'mes_printer_status', '0', 'admin', '2023-09-01 11:00:59', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (136, '生产工单类型', 'mes_workorder_type', '0', 'admin', '2023-10-29 22:15:59', '', NULL, NULL, NULL, NULL, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (1787760885981257729, '客户订单材料层级', 'mes_item_level', '0', 'admin', '2024-05-07 16:26:25', 'admin', '2024-05-07 16:26:25', NULL, 1, 1, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (1794761403068403713, '客户订单状态', 'mes_client_order_status', '0', 'admin', '2024-05-27 00:03:58', 'admin', '2024-05-27 00:03:58', NULL, 1, 1, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (1800060729982246914, '模块类型', 'sys_module_type', '0', 'admin', '2024-06-10 15:01:36', 'admin', '2024-06-10 15:39:55', NULL, 1, 1, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (1811298521353605121, '婚姻状况', 'hrm_marital_status', '0', 'admin', '2024-07-11 15:16:34', 'admin', '2024-07-11 15:16:34', NULL, 1, 1, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (1811300011858251778, '政治面貌', 'hrm_political_outlook', '0', 'admin', '2024-07-11 15:22:30', 'admin', '2024-07-11 15:22:30', NULL, 1, 1, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (1811300720372666369, '学历', 'hrm_education', '0', 'admin', '2024-07-11 15:25:19', 'admin', '2024-07-11 15:25:19', '', 1, 1, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (1811302821911908354, '员工登记状态', 'hrm_staff_status', '0', 'admin', '2024-07-11 15:33:40', 'admin', '2024-07-11 15:33:40', NULL, 1, 1, 0, '1000-01-01 00:00:00', 1);
INSERT INTO `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `create_user_id`, `update_user_id`, `deleted`, `deleteAt`, `version`) VALUES (1811329501246271490, '民族', 'hrm_ethnicity', '0', 'admin', '2024-07-11 17:19:41', 'admin', '2024-07-11 17:19:41', NULL, 1, 1, 0, '1000-01-01 00:00:00', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

CREATE TABLE hrm_rank (
                          rank_id BIGINT AUTO_INCREMENT PRIMARY KEY COMMENT '职级主键id',
                          rank_code VARCHAR ( 64 ) NOT NULL COMMENT '职级编码',
                          rank_type VARCHAR ( 64 ) NOT NULL COMMENT '职级层次',
                          rank_name VARCHAR ( 64 ) NOT NULL COMMENT '职级层次名称',
                          salary_range_min DECIMAL ( 10, 2 ) NOT NULL COMMENT '薪资范围下限',
                          salary_range_max DECIMAL ( 10, 2 ) NOT NULL COMMENT '薪资范围上限',
                          create_user_id BIGINT COMMENT '创建者id',
                          create_by VARCHAR ( 64 ) COMMENT '创建者',
                          update_user_id BIGINT COMMENT '修改者id',
                          update_by VARCHAR ( 64 ) COMMENT '修改者',
                          create_time DATETIME COMMENT '创建时间',
                          update_time DATETIME COMMENT '修改时间',
                          deleted INT DEFAULT 0 COMMENT '逻辑删除字段 0:未删除 1:已删除',
                          deleteAt DATETIME DEFAULT '1000-01-01 00:00:00' COMMENT '逻辑删除辅助字段',
                          version INT DEFAULT 1 COMMENT '乐观锁',
                          remark VARCHAR ( 255 ) COMMENT '备注'
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '职级表';
ALTER TABLE hrm_staff
    ADD COLUMN actual_salary DECIMAL ( 10, 2 ) COMMENT '实际薪资',
    ADD COLUMN rank_id BIGINT COMMENT '职级主键id',
    ADD COLUMN rank_code VARCHAR ( 64 ) COMMENT '职级编码',
    ADD COLUMN rank_name VARCHAR ( 64 ) COMMENT '职级层次名称';
